explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8J2j

Settings
# exclusive inclusive rows x rows loops node
1. 8,481.497 15,320.024 ↓ 1.0 842,072 1

Hash Left Join (cost=75,516.06..468,021.29 rows=838,817 width=380) (actual time=1,810.035..15,320.024 rows=842,072 loops=1)

  • Hash Cond: (a.m_lst_state_id = aps_last.id)
2. 571.493 6,838.509 ↓ 1.0 842,072 1

Hash Left Join (cost=75,514.72..211,739.35 rows=838,817 width=253) (actual time=1,808.868..6,838.509 rows=842,072 loops=1)

  • Hash Cond: (a.application_state_id = aps.id)
3. 2,592.419 6,266.997 ↓ 1.0 842,072 1

Hash Right Join (cost=75,513.38..208,914.00 rows=838,817 width=214) (actual time=1,808.832..6,266.997 rows=842,072 loops=1)

  • Hash Cond: (ac.id = a.app_state_last_id)
4. 1,866.908 1,866.908 ↑ 1.0 3,008,122 1

Seq Scan on application_state_changes ac (cost=0.00..60,591.87 rows=3,008,687 width=16) (actual time=0.493..1,866.908 rows=3,008,122 loops=1)

5. 631.740 1,807.670 ↓ 1.0 842,072 1

Hash (cost=41,272.17..41,272.17 rows=838,817 width=206) (actual time=1,807.669..1,807.670 rows=842,072 loops=1)

  • Buckets: 32768 Batches: 64 Memory Usage: 2775kB
6. 1,175.930 1,175.930 ↓ 1.0 842,072 1

Seq Scan on application a (cost=0.00..41,272.17 rows=838,817 width=206) (actual time=0.007..1,175.930 rows=842,072 loops=1)

7. 0.009 0.019 ↑ 1.0 15 1

Hash (cost=1.15..1.15 rows=15 width=43) (actual time=0.018..0.019 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
8. 0.010 0.010 ↑ 1.0 15 1

Seq Scan on application_state aps (cost=0.00..1.15 rows=15 width=43) (actual time=0.005..0.010 rows=15 loops=1)

9. 0.012 0.018 ↑ 1.0 15 1

Hash (cost=1.15..1.15 rows=15 width=43) (actual time=0.018..0.018 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
10. 0.006 0.006 ↑ 1.0 15 1

Seq Scan on application_state aps_last (cost=0.00..1.15 rows=15 width=43) (actual time=0.002..0.006 rows=15 loops=1)