explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UQM2

Settings
# exclusive inclusive rows x rows loops node
1. 8.037 26.609 ↓ 0.0 0 1

Gather (cost=1,000.43..1,149.46 rows=1 width=137) (actual time=24.893..26.609 rows=0 loops=1)

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

Limit (cost=0.43..149.36 rows=1 width=137) (actual time=18.572..18.572 rows=0 loops=1)

3. 18.569 18.569 ↓ 0.0 0 1

Index Scan using outcoming_2019_05_postamat_id_index on outcoming_2019_05 (cost=0.43..20,105.92 rows=135 width=137) (actual time=18.569..18.569 rows=0 loops=1)

  • Index Cond: ((postamat_id)::text = '00-7700222'::text)
  • Filter: ((method)::text = 'reserv'::text)
Planning time : 0.150 ms
Execution time : 26.645 ms