explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fOXwe

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 19,593.950 ↑ 1.0 4 1

Unique (cost=1,458,411.46..1,458,411.49 rows=4 width=40) (actual time=19,593.946..19,593.950 rows=4 loops=1)

  • Buffers: shared hit=115844 read=902071
  • I/O Timings: read=6219.552
2. 0.092 19,593.946 ↑ 1.0 4 1

Sort (cost=1,458,411.46..1,458,411.47 rows=4 width=40) (actual time=19,593.946..19,593.946 rows=4 loops=1)

  • Sort Key: ('commands created'::text), (count(*))
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=115844 read=902071
  • I/O Timings: read=6219.552
3. 0.005 19,593.854 ↑ 1.0 4 1

Append (cost=366,469.79..1,458,411.42 rows=4 width=40) (actual time=4,616.061..19,593.854 rows=4 loops=1)

  • Buffers: shared hit=115841 read=902071
  • I/O Timings: read=6219.552
4. 0.031 4,616.069 ↑ 1.0 1 1

Aggregate (cost=366,469.79..366,469.82 rows=1 width=40) (actual time=4,616.061..4,616.069 rows=1 loops=1)

  • Buffers: shared hit=43098 read=211380
  • I/O Timings: read=1025.011
5. 4,616.038 4,616.038 ↑ 8.2 36 1

Seq Scan on command (cost=0.00..366,469.05 rows=297 width=0) (actual time=2,040.763..4,616.038 rows=36 loops=1)

  • Filter: (creation_timestamp > (now() - '00:01:00'::interval))
  • Rows Removed by Filter: 3005459
  • Buffers: shared hit=43098 read=211380
  • I/O Timings: read=1025.011
6. 0.023 4,768.668 ↑ 1.0 1 1

Aggregate (cost=366,469.17..366,469.20 rows=1 width=40) (actual time=4,768.667..4,768.668 rows=1 loops=1)

  • Buffers: shared hit=23495 read=230983
  • I/O Timings: read=1598.354
7. 4,768.645 4,768.645 ↑ 1.2 39 1

Seq Scan on command command_1 (cost=0.00..366,469.05 rows=47 width=0) (actual time=2,141.022..4,768.645 rows=39 loops=1)

  • Filter: (completed_on > (now() - '00:01:00'::interval))
  • Rows Removed by Filter: 3005456
  • Buffers: shared hit=23495 read=230983
  • I/O Timings: read=1598.354
8. 0.015 4,716.236 ↑ 1.0 1 1

Aggregate (cost=351,537.10..351,537.13 rows=1 width=40) (actual time=4,716.236..4,716.236 rows=1 loops=1)

  • Buffers: shared hit=23320 read=231158
  • I/O Timings: read=1667.168
9. 4,716.221 4,716.221 ↑ 25.0 3 1

Seq Scan on command command_2 (cost=0.00..351,536.91 rows=75 width=0) (actual time=2,304.525..4,716.221 rows=3 loops=1)

  • Filter: ((status)::text = 'IN_PROGRESS'::text)
  • Rows Removed by Filter: 3005492
  • Buffers: shared hit=23320 read=231158
  • I/O Timings: read=1667.168
10. 0.008 5,492.876 ↑ 1.0 1 1

Aggregate (cost=373,935.12..373,935.15 rows=1 width=40) (actual time=5,492.876..5,492.876 rows=1 loops=1)

  • Buffers: shared hit=25928 read=228550
  • I/O Timings: read=1929.019
11. 5,492.868 5,492.868 ↓ 0.0 0 1

Seq Scan on command command_3 (cost=0.00..373,935.12 rows=1 width=0) (actual time=5,492.868..5,492.868 rows=0 loops=1)

  • Filter: (((status)::text = ANY ('{FAILED,PERMANENTLY_FAILED}'::text[])) AND (in_progress_since > (now() - '00:01:00'::interval)))
  • Rows Removed by Filter: 3005495
  • Buffers: shared hit=25928 read=228550
  • I/O Timings: read=1929.019
Planning time : 37.015 ms
Execution time : 19,626.016 ms