explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UJM

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=9,774.09..9,775.24 rows=1 width=102) (actual rows= loops=)

  • Hash Cond: (("outer".aeic)::text = ("inner".id)::text)
2. 0.000 0.000 ↓ 0.0

XN Seq Scan on units u (cost=0.00..1.12 rows=1 width=39) (actual rows= loops=)

  • Filter: ((aeic)::text = '310467'::text)
3. 0.000 0.000 ↓ 0.0

XN Hash (cost=9,774.09..9,774.09 rows=1 width=73) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

XN Seq Scan on pdc_gpn_map m (cost=0.00..9,774.09 rows=1 width=73) (actual rows= loops=)

  • Filter: (((gpn)::text = 'MW'::text) AND ('310467'::text = (id)::text) AND (mapping_end > '2019-05-05 00:00:00'::timestamp without time zone) AND ((id_type)::text = 'AEIC'::text) AND (mapping_start <= '2019-05-01 00:00:00'::timestamp without time zone))