|
|
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 |
| … |
|
