explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lTo4

Settings
# exclusive inclusive rows x rows loops node
1. 38.418 7,383.445 ↓ 0.0 0 1

Gather (cost=1,000.43..5,373.92 rows=1 width=137) (actual time=7,352.354..7,383.445 rows=0 loops=1)

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

Limit (cost=0.43..4,373.82 rows=1 width=137) (actual time=7,345.026..7,345.027 rows=0 loops=1)

3. 7,345.023 7,345.023 ↓ 0.0 0 1

Index Scan Backward using outcoming_2019_05_pk on outcoming_2019_05 (cost=0.43..590,407.41 rows=135 width=137) (actual time=7,345.023..7,345.023 rows=0 loops=1)

  • Filter: (((postamat_id)::text = '00-7700222'::text) AND ((method)::text = 'reserv'::text))
  • Rows Removed by Filter: 10743600
Planning time : 0.249 ms
Execution time : 7,383.502 ms