explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YnVF : report_bans

Settings
# exclusive inclusive rows x rows loops node
1. 0.523 269.578 ↓ 166.7 1,000 1

Limit (cost=1,000.00..2,107,124.10 rows=6 width=256) (actual time=9.023..269.578 rows=1,000 loops=1)

  • Buffers: shared hit=1 read=4494 dirtied=4494 written=4270
  • I/O Timings: read=407.199 write=926.376
2. 68.390 269.055 ↓ 166.7 1,000 1

Gather (cost=1,000.00..2,107,124.10 rows=6 width=256) (actual time=9.021..269.055 rows=1,000 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
  • Buffers: shared hit=1 read=4494 dirtied=4494 written=4270
  • I/O Timings: read=407.199 write=926.376
3. 200.665 200.665 ↓ 145.0 145 7

Parallel Seq Scan on report_mv_bans_per_minute (cost=0.00..2,106,123.50 rows=1 width=256) (actual time=1.536..200.665 rows=145 loops=7)

  • Filter: ((endtime_num >= 1549490400) AND (endtime_num <= 1549576799) AND (smsc = 'cosmotegr'::text) AND (mcc_mnc = '20201'::text))
  • Rows Removed by Filter: 27085
  • Buffers: shared hit=1 read=4494 dirtied=4494 written=4270
  • I/O Timings: read=407.199 write=926.376