explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9JwD

Settings
# exclusive inclusive rows x rows loops node
1. 85.302 521.084 ↓ 1.0 99,942 1

Sort (cost=160,811.48..161,060.37 rows=99,556 width=1,114) (actual time=493.210..521.084 rows=99,942 loops=1)

  • Sort Key: nt_queue_message.priority
  • Sort Method: external merge Disk: 12736kB
  • Functions: 40
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 5.148 ms, Inlining 0.000 ms, Optimization 1.239 ms, Emission 27.345 ms, Total 33.732 ms
2. 34.886 435.782 ↓ 1.0 99,942 1

Hash Join (cost=8,532.56..55,225.73 rows=99,556 width=1,114) (actual time=117.851..435.782 rows=99,942 loops=1)

  • Hash Cond: (nt_queue_message.to_entity_id = overseeent6_.entity_id)
3. 17.106 371.913 ↓ 1.0 99,942 1

Nested Loop (cost=8,521.44..54,682.23 rows=99,556 width=606) (actual time=88.861..371.913 rows=99,942 loops=1)

4. 0.003 0.056 ↑ 1.0 1 1

Nested Loop (cost=0.43..10.87 rows=1 width=532) (actual time=0.052..0.056 rows=1 loops=1)

5. 0.003 0.047 ↑ 1.0 1 1

Nested Loop (cost=0.29..9.99 rows=1 width=20) (actual time=0.043..0.047 rows=1 loops=1)

6. 0.004 0.037 ↑ 1.0 1 1

Nested Loop (cost=0.14..9.62 rows=1 width=20) (actual time=0.033..0.037 rows=1 loops=1)

7. 0.018 0.018 ↑ 1.0 1 1

Seq Scan on nt_queue queueentit2_ (cost=0.00..1.39 rows=1 width=20) (actual time=0.014..0.018 rows=1 loops=1)

  • Filter: (queue_id = 37)
  • Rows Removed by Filter: 30
8. 0.015 0.015 ↑ 1.0 1 1

Index Scan using pk_nt_outbox on nt_outbox outboxenti3_ (cost=0.14..8.16 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (outbox_id = queueentit2_.outbox_id)
9. 0.007 0.007 ↑ 1.0 1 1

Index Scan using pk_nt_transmitter on nt_transmitter transmitte4_ (cost=0.14..0.37 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (transmitter_id = outboxenti3_.transmitter_id)
10. 0.006 0.006 ↑ 1.0 1 1

Index Scan using pk_ovs_entity on ovs_entity overseeent5_ (cost=0.14..0.84 rows=1 width=520) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (entity_id = transmitte4_.station_id)
11. 102.485 354.751 ↓ 1.0 99,942 1

Hash Join (cost=8,521.01..53,675.81 rows=99,556 width=82) (actual time=88.805..354.751 rows=99,942 loops=1)

  • Hash Cond: (nt_queue_message.message_id = nt_message.message_id)
12. 174.359 182.840 ↓ 1.0 99,942 1

Bitmap Heap Scan on nt_queue_message (cost=2,967.99..45,522.44 rows=99,556 width=32) (actual time=19.217..182.840 rows=99,942 loops=1)

  • Recheck Cond: (queue_id = 37)
  • Heap Blocks: exact=39978
13. 8.481 8.481 ↓ 1.0 99,942 1

Bitmap Index Scan on idx_ntqm_01 (cost=0.00..2,943.10 rows=99,556 width=0) (actual time=8.481..8.481 rows=99,942 loops=1)

  • Index Cond: (queue_id = 37)
14. 33.596 69.426 ↑ 1.0 100,001 1

Hash (cost=3,326.01..3,326.01 rows=100,001 width=54) (actual time=69.426..69.426 rows=100,001 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2663kB
15. 35.830 35.830 ↑ 1.0 100,001 1

Seq Scan on nt_message (cost=0.00..3,326.01 rows=100,001 width=54) (actual time=0.049..35.830 rows=100,001 loops=1)

16. 0.007 28.983 ↑ 50.0 1 1

Hash (cost=10.50..10.50 rows=50 width=520) (actual time=28.983..28.983 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
17. 28.976 28.976 ↑ 50.0 1 1

Seq Scan on ovs_entity overseeent6_ (cost=0.00..10.50 rows=50 width=520) (actual time=28.973..28.976 rows=1 loops=1)

Planning time : 1.390 ms
Execution time : 535.030 ms