explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S3j4

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 3,317.906 ↓ 5.0 5 1

Limit (cost=161,943.12..161,943.13 rows=1 width=646) (actual time=3,317.903..3,317.906 rows=5 loops=1)

  • Buffers: shared hit=12405 read=115999 dirtied=1 written=1
  • I/O Timings: read=1360.779 write=0.027
2. 0.059 3,317.903 ↓ 5.0 5 1

Sort (cost=161,943.12..161,943.13 rows=1 width=646) (actual time=3,317.901..3,317.903 rows=5 loops=1)

  • Sort Key: creation_timestamp
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=12405 read=115999 dirtied=1 written=1
  • I/O Timings: read=1360.779 write=0.027
3. 3,317.844 3,317.844 ↓ 5.0 5 1

Seq Scan on event jpaeventwr0_ (cost=0.00..161,943.11 rows=1 width=646) (actual time=1,802.277..3,317.844 rows=5 loops=1)

  • Filter: ((status)::text = 'ACCEPTED'::text)
  • Rows Removed by Filter: 1033469
  • Buffers: shared hit=12402 read=115999 dirtied=1 written=1
  • I/O Timings: read=1360.779 write=0.027
Planning time : 78.992 ms
Execution time : 3,318.030 ms