explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KfpN

Settings
# exclusive inclusive rows x rows loops node
1. 65.121 102,207.449 ↓ 0.0 0 1

Gather (cost=1,000.43..1,155.38 rows=1 width=137) (actual time=102,165.187..102,207.449 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Single Copy: true
2. 0.004 102,142.328 ↓ 0.0 0 1

Limit (cost=0.43..155.28 rows=1 width=137) (actual time=102,142.328..102,142.328 rows=0 loops=1)

3. 102,142.324 102,142.324 ↓ 0.0 0 1

Index Scan Backward using outcoming_2019_05_pk on outcoming_2019_05 (cost=0.43..590,407.41 rows=3,813 width=137) (actual time=102,142.324..102,142.324 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'status'::text))
  • Rows Removed by Filter: 10743600
Planning time : 0.200 ms
Execution time : 102,207.541 ms