explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 38qx

Settings
# exclusive inclusive rows x rows loops node
1. 26.274 180,835.465 ↑ 1.0 1 1

Aggregate (cost=594,394.24..594,394.25 rows=1 width=8) (actual time=180,835.464..180,835.465 rows=1 loops=1)

2. 180,809.191 180,809.191 ↑ 1.8 238,192 1

Index Only Scan using decis_det_ogai_kod on decis (cost=0.56..593,311.57 rows=433,069 width=0) (actual time=16,195.587..180,809.191 rows=238,192 loops=1)

  • Index Cond: ((ogai_sost_kod = '45597'::text) AND (decis_kod = '95'::numeric))
  • Heap Fetches: 28,806
Planning time : 0.114 ms
Execution time : 180,837.500 ms