explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hcSY

Settings
# exclusive inclusive rows x rows loops node
1. 100.050 811.651 ↓ 1.0 99,942 1

Nested Loop (cost=1,001.31..157,962.64 rows=99,556 width=1,114) (actual time=53.287..811.651 rows=99,942 loops=1)

  • Functions: 65
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 12.437 ms, Inlining 0.000 ms, Optimization 3.282 ms, Emission 62.229 ms, Total 77.947 ms
2. 0.000 711.601 ↓ 1.0 99,942 1

Gather Merge (cost=1,000.89..156,450.41 rows=99,556 width=594) (actual time=53.206..711.601 rows=99,942 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 112.575 1,812.873 ↑ 1.2 33,314 3

Nested Loop (cost=0.86..143,959.15 rows=41,482 width=594) (actual time=22.195..604.291 rows=33,314 loops=3)

4. 78.528 1,600.356 ↑ 1.2 33,314 3

Nested Loop (cost=0.72..137,419.75 rows=41,482 width=82) (actual time=22.170..533.452 rows=33,314 loops=3)

5. 1,222.002 1,222.002 ↑ 1.2 33,314 3

Parallel Index Scan using idx_ntqm_priority on nt_queue_message (cost=0.43..120,223.63 rows=41,482 width=32) (actual time=22.129..407.334 rows=33,314 loops=3)

  • Filter: (queue_id = 37)
  • Rows Removed by Filter: 999424
6. 299.826 299.826 ↑ 1.0 1 99,942

Index Scan using pk_nt_message on nt_message (cost=0.29..0.41 rows=1 width=54) (actual time=0.003..0.003 rows=1 loops=99,942)

  • Index Cond: (message_id = nt_queue_message.message_id)
7. 99.942 99.942 ↑ 1.0 1 99,942

Index Scan using pk_ovs_entity on ovs_entity overseeent6_ (cost=0.14..0.16 rows=1 width=520) (actual time=0.001..0.001 rows=1 loops=99,942)

  • Index Cond: (entity_id = nt_queue_message.to_entity_id)
8. 0.000 0.000 ↑ 1.0 1 99,942

Materialize (cost=0.43..18.90 rows=1 width=532) (actual time=0.000..0.000 rows=1 loops=99,942)

9. 0.004 0.077 ↑ 1.0 1 1

Nested Loop (cost=0.43..18.89 rows=1 width=532) (actual time=0.074..0.077 rows=1 loops=1)

10. 0.005 0.068 ↑ 1.0 1 1

Nested Loop (cost=0.29..18.02 rows=1 width=20) (actual time=0.066..0.068 rows=1 loops=1)

11. 0.005 0.057 ↑ 1.0 1 1

Nested Loop (cost=0.14..9.64 rows=1 width=20) (actual time=0.055..0.057 rows=1 loops=1)

12. 0.044 0.044 ↑ 1.0 1 1

Seq Scan on nt_queue queueentit2_ (cost=0.00..1.46 rows=1 width=20) (actual time=0.043..0.044 rows=1 loops=1)

  • Filter: ((queue_id = 37) AND (outbox_id = 1))
  • Rows Removed by Filter: 30
13. 0.008 0.008 ↑ 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.007..0.008 rows=1 loops=1)

  • Index Cond: (outbox_id = 1)
14. 0.006 0.006 ↑ 1.0 1 1

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

  • Index Cond: (transmitter_id = outboxenti3_.transmitter_id)
15. 0.005 0.005 ↑ 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.005..0.005 rows=1 loops=1)

  • Index Cond: (entity_id = transmitte4_.station_id)
Planning time : 1.268 ms
Execution time : 835.586 ms