explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7pV6

Settings
# exclusive inclusive rows x rows loops node
1. 0.500 0.535 ↑ 1.0 1 1

Gather (cost=1,000.00..1,000.15 rows=1 width=137) (actual time=0.488..0.535 rows=1 loops=1)

  • Workers Planned: 1
  • Workers Launched: 0
  • Single Copy: true
2. 0.001 0.035 ↑ 1.0 1 1

Limit (cost=0.00..0.05 rows=1 width=137) (actual time=0.034..0.035 rows=1 loops=1)

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

Seq Scan on outcoming_2019_05 (cost=0.00..368,507.86 rows=8,145,227 width=137) (actual time=0.033..0.034 rows=1 loops=1)

  • Filter: ((method)::text = 'status'::text)