|
EXPLAIN (ANALYZE, TIMING OFF)
SELECT
pa.x, pa.y, ch.b, ch.t
FROM
parent pa
JOIN child ch
ON pa.x = REPLACE(ch.b, 'Ref:', '')::INT
WHERE REPLACE(ch.b, 'Ref:', '')::INT = 23;
QUERY PLAN |
Nested Loop (cost=0.15..35.81 rows=4 width=100) (actual rows=5 loops=1) |
-> Index Scan using parent_pkey on parent pa (cost=0.15..8.17 rows=1 width=36) (actual rows=1 loops=1) |
Index Cond: (x = 23) |
-> Seq Scan on child ch (cost=0.00..27.60 rows=4 width=64) (actual rows=5 loops=1) |
Filter: ((replace(b, 'Ref:'::text, ''::text))::integer = 23) |
Rows Removed by Filter: 495 |
Planning Time: 0.095 ms |
Execution Time: 0.176 ms |
… |
|