explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cWbJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.165 ↓ 0.0 0 1

Sort (cost=147.69..147.70 rows=1 width=20) (actual time=0.165..0.165 rows=0 loops=1)

  • Sort Key: priority DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.106 0.158 ↓ 0.0 0 1

Bitmap Heap Scan on ded_manual_doc (cost=9.00..147.68 rows=1 width=20) (actual time=0.158..0.158 rows=0 loops=1)

  • Recheck Cond: (((id_nitg)::text = 'G511'::text) OR ((id_part)::text = ''::text))
  • Filter: (status AND ((veh_manuf_begin_date IS NULL) OR (veh_manuf_begin_date <= '2020-01-01'::date)) AND ((veh_manuf_end_date IS NULL) OR (veh_manuf_end_date >= '1980-01-01'::date)) AND ((id_assembly_plant IS NULL) OR ((id_assembly_plant)::text = '039'::text)) AND ((project IS NULL) OR ((project)::text = 'X84'::text)) AND ((index_body IS NULL) OR ((index_body)::text = 'J84'::text)) AND ((doc_type)::text = 'E'::text))
  • Rows Removed by Filter: 55
  • Heap Blocks: exact=49
3. 0.000 0.052 ↓ 0.0 0 1

BitmapOr (cost=9.00..9.00 rows=56 width=0) (actual time=0.052..0.052 rows=0 loops=1)

4. 0.045 0.045 ↑ 1.0 55 1

Bitmap Index Scan on ded_manual_doc_id_nitg_i (cost=0.00..4.70 rows=55 width=0) (actual time=0.045..0.045 rows=55 loops=1)

  • Index Cond: ((id_nitg)::text = 'G511'::text)
5. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on ded_manual_id_part_i (cost=0.00..4.29 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((id_part)::text = ''::text)
Planning time : 0.150 ms
Execution time : 0.205 ms