explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7a0A

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.140 ↓ 3.0 3 1

Sort (cost=142.18..142.18 rows=1 width=20) (actual time=0.140..0.140 rows=3 loops=1)

  • Sort Key: priority DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.100 0.129 ↓ 3.0 3 1

Bitmap Heap Scan on ded_manual_doc (cost=9.00..142.17 rows=1 width=20) (actual time=0.049..0.129 rows=3 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 = 'V'::text) OR ((doc_type)::text = 'M'::text) OR ((doc_type)::text = 'B'::text)))
  • Rows Removed by Filter: 52
  • Heap Blocks: exact=51
3. 0.000 0.029 ↓ 0.0 0 1

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

4. 0.024 0.024 ↑ 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.024..0.024 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.147 ms
Execution time : 0.171 ms