explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9gm2

Settings
# exclusive inclusive rows x rows loops node
1. 66.465 35,811.459 ↓ 0.0 0 1

Gather (cost=1,000.43..1,112.43 rows=1 width=137) (actual time=35,769.746..35,811.459 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Single Copy: true
2. 0.003 35,744.994 ↓ 0.0 0 1

Limit (cost=0.43..112.33 rows=1 width=137) (actual time=35,744.994..35,744.994 rows=0 loops=1)

3. 35,744.991 35,744.991 ↓ 0.0 0 1

Index Scan Backward using outcoming_2019_05_pk on outcoming_2019_05 (cost=0.43..563,513.63 rows=5,036 width=137) (actual time=35,744.991..35,744.991 rows=0 loops=1)

  • Filter: ((postamat_id)::text = '00-7700222'::text)
  • Rows Removed by Filter: 10743600