explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bM5

Settings
# exclusive inclusive rows x rows loops node
1. 0.062 67.528 ↓ 0.0 0 1

Nested Loop (cost=8.74..376.06 rows=1 width=22) (actual time=67.528..67.528 rows=0 loops=1)

2. 0.094 10.214 ↓ 1.4 13 1

Bitmap Heap Scan on set_info si (cost=4.38..44.28 rows=9 width=6) (actual time=10.138..10.214 rows=13 loops=1)

  • Recheck Cond: ((id_invoiced_supplier)::text = '026008'::text)
  • Filter: ((set_perimeter = 1) AND (status = 1))
  • Heap Blocks: exact=9
3. 10.120 10.120 ↑ 1.0 13 1

Bitmap Index Scan on set_info_invoiced_supplier_i (cost=0.00..4.38 rows=13 width=0) (actual time=10.120..10.120 rows=13 loops=1)

  • Index Cond: ((id_invoiced_supplier)::text = '026008'::text)
4. 49.673 57.252 ↓ 0.0 0 13

Bitmap Heap Scan on set_link sl (cost=4.36..36.85 rows=1 width=22) (actual time=4.404..4.404 rows=0 loops=13)

  • Recheck Cond: ((id_set)::text = (si.id_set)::text)
  • Filter: (active AND ((veh_manuf_begin_date IS NULL) OR (veh_manuf_begin_date <= '2019-08-08'::date)) AND ((veh_manuf_end_date IS NULL) OR (veh_manuf_end_date >= '2019-08-08'::date)) AND ((id_nitg)::text = '1'::text) AND (((project IS NOT NULL) AND ((id_assembly_dept IS NULL) OR ((id_assembly_dept)::text = '1'::text)) AND ((project IS NULL) OR ((project)::text = '1'::text)) AND ((index_info IS NULL) OR ((index_info)::text = '1'::text)) AND (((project_type)::text = 'VEH'::text) OR ((project_type)::text = 'MOT'::text) OR ((project_type)::text = 'BV'::text))) OR (project IS NULL)))
  • Rows Removed by Filter: 17
  • Heap Blocks: exact=60
5. 7.579 7.579 ↓ 1.9 17 13

Bitmap Index Scan on set_link_id_set_i (cost=0.00..4.36 rows=9 width=0) (actual time=0.583..0.583 rows=17 loops=13)

  • Index Cond: ((id_set)::text = (si.id_set)::text)
Planning time : 0.474 ms