explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uLUc

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.133 ↓ 0.0 0 1

Sort (cost=141.90..141.91 rows=1 width=20) (actual time=0.133..0.133 rows=0 loops=1)

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

Bitmap Heap Scan on ded_manual_doc (cost=9.00..141.89 rows=1 width=20) (actual time=0.128..0.128 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=51
3. 0.001 0.028 ↓ 0.0 0 1

BitmapOr (cost=9.00..9.00 rows=55 width=0) (actual time=0.027..0.028 rows=0 loops=1)

4. 0.022 0.022 ↑ 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.022..0.022 rows=55 loops=1)

  • Index Cond: ((id_nitg)::text = 'G511'::text)
5. 0.005 0.005 ↓ 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.005..0.005 rows=0 loops=1)

  • Index Cond: ((id_part)::text = ''::text)
Planning time : 0.130 ms
Execution time : 0.161 ms