explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EoSp

Settings
# exclusive inclusive rows x rows loops node
1. 0.030 43.026 ↓ 3.0 3 1

Sort (cost=147.97..147.98 rows=1 width=20) (actual time=43.025..43.026 rows=3 loops=1)

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

Bitmap Heap Scan on ded_manual_doc (cost=9.00..147.96 rows=1 width=20) (actual time=42.907..42.996 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=49
3. 0.006 42.852 ↓ 0.0 0 1

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

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

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

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

  • Index Cond: ((id_part)::text = ''::text)
Planning time : 0.258 ms
Execution time : 43.076 ms