explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6KuH

Settings
# exclusive inclusive rows x rows loops node
1. 0.048 45.774 ↓ 3.0 3 1

"Sort (cost=142.18..142.18 rows=1 width=20) (actual time=45.773..45.774 rows=3 loops=1)

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

Bitmap Heap Scan on ded_manual_doc (cost=9.00..142.17 rows=1 width=20) (actual time=6.448..45.726 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.001 2.709 ↓ 0.0 0 1

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

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

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

  • Index Cond: ((id_part)::text = ''::text)
Planning time : 11.501 ms
Execution time : 45.844 ms