explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1M7w

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 17.219 ↓ 17.0 17 1

Limit (cost=4,028.79..4,028.79 rows=1 width=2,211) (actual time=17.217..17.219 rows=17 loops=1)

2. 0.053 17.216 ↓ 17.0 17 1

Sort (cost=4,028.79..4,028.79 rows=1 width=2,211) (actual time=17.215..17.216 rows=17 loops=1)

  • Sort Key: keyseq, keyprog
  • Sort Method: quicksort Memory: 42kB
3. 16.369 17.163 ↓ 17.0 17 1

Bitmap Heap Scan on outdoc (cost=52.31..4,028.78 rows=1 width=2,211) (actual time=1.686..17.163 rows=17 loops=1)

  • Recheck Cond: (((azieid)::text = 'MONTEFARMACO'::text) AND ((docid)::text = 'FATTURA_XML_OUT'::text))
  • Filter: ((field02)::text = '04939680759'::text)
  • Rows Removed by Filter: 2,496
  • Heap Blocks: exact=552
4. 0.794 0.794 ↓ 2.1 2,522 1

Bitmap Index Scan on outdoc_idx1 (cost=0.00..52.31 rows=1,189 width=0) (actual time=0.794..0.794 rows=2,522 loops=1)

  • Index Cond: (((azieid)::text = 'MONTEFARMACO'::text) AND ((docid)::text = 'FATTURA_XML_OUT'::text))
Planning time : 0.378 ms
Execution time : 17.349 ms