explain.depesz.com

PostgreSQL's explain analyze made readable

Result: njre

Settings
# exclusive inclusive rows x rows loops node
1. 10,374.777 127,572.621 ↑ 1.0 7,529,590 1

Hash Join (cost=248,392.40..1,452,302.94 rows=7,530,268 width=411) (actual time=1,542.422..127,572.621 rows=7,529,590 loops=1)

  • Hash Cond: (("Fee".workobjectreference)::text = ("UN1".pyid)::text)
2. 115,656.186 115,656.186 ↑ 1.0 7,530,268 1

Seq Scan on pr_mw_fw_uapfw_data_reconcilia "Fee" (cost=0.00..930,829.35 rows=7,530,268 width=44) (actual time=0.009..115,656.186 rows=7,530,268 loops=1)

  • Filter: ((pxobjclass)::text = 'MW-FW-UAPFW-Data-Reconciliation-Inbound'::text)
3. 434.942 1,541.658 ↑ 1.2 609,671 1

Hash (cost=201,891.20..201,891.20 rows=746,336 width=377) (actual time=1,541.658..1,541.658 rows=609,671 loops=1)

  • Buckets: 524288 Batches: 4 Memory Usage: 32972kB
4. 1,106.716 1,106.716 ↑ 1.2 609,671 1

Seq Scan on mw_sd_mwdss_work_atlasjob "UN1" (cost=0.00..201,891.20 rows=746,336 width=377) (actual time=0.006..1,106.716 rows=609,671 loops=1)

  • Filter: ((pxobjclass)::text = 'MW-SD-DSS-WORK-ATLASJob'::text)