explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r2Lk

Settings
# exclusive inclusive rows x rows loops node
1. 6.830 43.118 ↓ 0.0 0 1

Gather (cost=1,000.43..1,004.52 rows=1 width=137) (actual time=41.317..43.118 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Single Copy: true
2. 0.003 36.288 ↓ 0.0 0 1

Limit (cost=0.43..4.42 rows=1 width=137) (actual time=36.288..36.288 rows=0 loops=1)

3. 36.285 36.285 ↓ 0.0 0 1

Index Scan using outcoming_2019_05_postamat_id_index on outcoming_2019_05 (cost=0.43..20,093.33 rows=5,036 width=137) (actual time=36.285..36.285 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
Planning time : 0.173 ms
Execution time : 43.166 ms