explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oLqH

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 44.630 ↓ 0.0 0 1

Nested Loop (cost=8.66..85.32 rows=1 width=22) (actual time=44.630..44.630 rows=0 loops=1)

2. 0.003 44.629 ↓ 0.0 0 1

Bitmap Heap Scan on set_info si (cost=4.30..11.59 rows=2 width=6) (actual time=44.629..44.629 rows=0 loops=1)

  • Recheck Cond: ((id_invoiced_supplier)::text = '1'::text)
  • Filter: ((set_perimeter = 1) AND (status = 1))
3. 44.626 44.626 ↓ 0.0 0 1

Bitmap Index Scan on set_info_invoiced_supplier_i (cost=0.00..4.30 rows=2 width=0) (actual time=44.626..44.626 rows=0 loops=1)

  • Index Cond: ((id_invoiced_supplier)::text = '1'::text)
4. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on set_link sl (cost=4.36..36.85 rows=1 width=22) (never executed)

  • 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)))
5. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on set_link_id_set_i (cost=0.00..4.36 rows=9 width=0) (never executed)

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