explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wTdG

Settings
# exclusive inclusive rows x rows loops node
1. 0.824 7.682 ↑ 1.0 1 1

Gather (cost=1,000.43..1,000.60 rows=1 width=137) (actual time=7.567..7.682 rows=1 loops=1)

  • Workers Planned: 1
  • Workers Launched: 0
  • Single Copy: true
2. 0.005 6.858 ↑ 1.0 1 1

Limit (cost=0.43..0.50 rows=1 width=137) (actual time=6.856..6.858 rows=1 loops=1)

3. 6.853 6.853 ↑ 8,145,227.0 1 1

Index Scan Backward using outcoming_2019_05_pk on outcoming_2019_05 (cost=0.43..563,513.63 rows=8,145,227 width=137) (actual time=6.853..6.853 rows=1 loops=1)

  • Filter: ((method)::text = 'status'::text)
Planning time : 0.219 ms
Execution time : 7.736 ms