explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vuHs : new func

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 102.781 ↑ 1.0 1 1

Subquery Scan on t1 (cost=22,991.12..22,991.13 rows=1 width=32) (actual time=102.779..102.781 rows=1 loops=1)

2. 0.015 102.777 ↑ 1.0 1 1

Aggregate (cost=22,991.12..22,991.12 rows=1 width=96) (actual time=102.776..102.777 rows=1 loops=1)

3.          

Initplan (forAggregate)

4. 0.062 95.690 ↑ 1.0 1 1

Aggregate (cost=15,444.84..15,444.84 rows=1 width=32) (actual time=95.690..95.690 rows=1 loops=1)

5. 4.859 95.628 ↓ 1.4 56 1

Hash Left Join (cost=4,218.39..15,444.76 rows=41 width=10) (actual time=91.923..95.628 rows=56 loops=1)

  • Hash Cond: ((intran_1.doc_aid)::text = (inmfg.autoid)::text)
  • Filter: ((arinv.progress = '40'::numeric) OR ((COALESCE((inmfg.start_date)::timestamp with time zone, now()) <= now()) AND (inmfg.status <> '1'::numeric)))
  • Rows Removed by Filter: 5208
6. 0.000 14.061 ↓ 1.4 5,264 1

Gather (cost=1,056.15..12,257.22 rows=3,876 width=30) (actual time=3.344..14.061 rows=5,264 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 15.726 19.776 ↓ 1.1 1,755 3

Nested Loop Left Join (cost=56.15..10,869.62 rows=1,615 width=30) (actual time=0.944..19.776 rows=1,755 loops=3)

8. 2.312 4.043 ↓ 1.1 1,755 3

Parallel Bitmap Heap Scan on intran intran_1 (cost=56.06..7,511.67 rows=1,615 width=26) (actual time=0.922..4.043 rows=1,755 loops=3)

  • Recheck Cond: (((inven)::text = 'AMLBBL'::text) AND ((warehouse)::text = '1-MAIN'::text))
  • Filter: ((doc_role)::text = 'O'::text)
  • Rows Removed by Filter: 100
  • Heap Blocks: exact=439
9. 1.731 1.731 ↓ 1.1 5,565 1

Bitmap Index Scan on idx_btree_inven_warehouse (cost=0.00..55.87 rows=4,892 width=0) (actual time=1.731..1.731 rows=5,565 loops=1)

  • Index Cond: (((inven)::text = 'AMLBBL'::text) AND ((warehouse)::text = '1-MAIN'::text))
10. 0.007 0.007 ↓ 0.0 0 5,264

Index Scan using arinv_pkey on arinv (cost=0.08..2.08 rows=1 width=21) (actual time=0.007..0.007 rows=0 loops=5,264)

  • Index Cond: ((intran_1.doc_aid)::text = (autoid)::text)
11. 34.353 76.708 ↓ 1.0 85,400 1

Hash (cost=2,863.80..2,863.80 rows=85,268 width=25) (actual time=76.708..76.708 rows=85,400 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 5830kB
12. 42.355 42.355 ↓ 1.0 85,400 1

Seq Scan on inmfg (cost=0.00..2,863.80 rows=85,268 width=25) (actual time=0.009..42.355 rows=85,400 loops=1)

13. 6.133 7.072 ↑ 1,598.0 3 1

Bitmap Heap Scan on intran (cost=56.11..7,531.89 rows=4,794 width=15) (actual time=6.409..7.072 rows=3 loops=1)

  • Recheck Cond: (((inven)::text = 'AMLBBL'::text) AND ((warehouse)::text = '1-MAIN'::text))
  • Filter: ((COALESCE(q_order_in, '0'::numeric) <> COALESCE(q_linked_p, '0'::numeric)) AND (COALESCE(q_ship_in, '0'::numeric) <> '0'::numeric) AND ((doc_status <> '0'::numeric) OR ((doc_role)::text <> 'O'::text)))
  • Rows Removed by Filter: 5562
  • Heap Blocks: exact=4541
14. 0.939 0.939 ↓ 1.1 5,565 1

Bitmap Index Scan on idx_btree_inven_warehouse (cost=0.00..55.87 rows=4,892 width=0) (actual time=0.939..0.939 rows=5,565 loops=1)

  • Index Cond: (((inven)::text = 'AMLBBL'::text) AND ((warehouse)::text = '1-MAIN'::text))