explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vNTA

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

Hash Join (cost=2,629.61..6,791.66 rows=11,563 width=271) (actual rows= loops=)

  • Hash Cond: ((a.qmgr)::text = (qmgr.name)::text)
2. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=2,609.13..6,625.47 rows=11,563 width=161) (actual rows= loops=)

  • Hash Cond: ((a.attributes ->> 'TARGET'::text) = (mq_object.name)::text)
3. 0.000 0.000 ↓ 0.0

Seq Scan on mq_object a (cost=0.00..2,047.74 rows=23,126 width=161) (actual rows= loops=)

  • Filter: (type = 'QALIAS'::mq_object)
4. 0.000 0.000 ↓ 0.0

Hash (cost=1,907.39..1,907.39 rows=56,139 width=25) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on mq_object (cost=0.00..1,907.39 rows=56,139 width=25) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=15.77..15.77 rows=377 width=110) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on qmgr (cost=0.00..15.77 rows=377 width=110) (actual rows= loops=)