explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6dvu

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 4,803.154 ↑ 12.5 6 1

Limit (cost=352,566.25..352,566.44 rows=75 width=640) (actual time=4,803.148..4,803.154 rows=6 loops=1)

  • Buffers: shared hit=36,472 read=217,942
  • I/O Timings: read=2,150.323
2. 0.063 4,803.150 ↑ 12.5 6 1

Sort (cost=352,566.25..352,566.44 rows=75 width=640) (actual time=4,803.146..4,803.150 rows=6 loops=1)

  • Sort Key: jpacommand0_.creation_timestamp
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=36,472 read=217,942
  • I/O Timings: read=2,150.323
3. 0.013 4,803.087 ↑ 12.5 6 1

Nested Loop Left Join (cost=0.00..352,563.92 rows=75 width=640) (actual time=98.384..4,803.087 rows=6 loops=1)

  • Join Filter: (jpacommand0_.flow_id = jpaflow1_.flow_id)
  • Filter: ((jpacommand0_.flow_id IS NULL) OR ((jpaflow1_.status)::text <> 'ACCEPTED'::text))
  • Buffers: shared hit=36,469 read=217,942
  • I/O Timings: read=2,150.323
4. 4,803.062 4,803.062 ↑ 12.5 6 1

Seq Scan on command jpacommand0_ (cost=0.00..351,444.36 rows=75 width=640) (actual time=98.363..4,803.062 rows=6 loops=1)

  • Filter: ((status)::text = 'ACCEPTED'::text)
  • Rows Removed by Filter: 3,004,899
  • Buffers: shared hit=36,469 read=217,942
  • I/O Timings: read=2,150.323
5. 0.009 0.012 ↓ 0.0 0 6

Materialize (cost=0.00..23.65 rows=390 width=66) (actual time=0.002..0.002 rows=0 loops=6)

6. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on flow jpaflow1_ (cost=0.00..21.70 rows=390 width=66) (actual time=0.003..0.003 rows=0 loops=1)

Planning time : 59.533 ms
Execution time : 4,803.321 ms