explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qPFy

Settings
# exclusive inclusive rows x rows loops node
1. 78.622 735.584 ↑ 1.1 99,942 1

Nested Loop (cost=1,001.31..161,219.20 rows=109,574 width=1,114) (actual time=47.503..735.584 rows=99,942 loops=1)

  • Functions: 65
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 10.408 ms, Inlining 0.000 ms, Optimization 3.350 ms, Emission 57.879 ms, Total 71.637 ms
2. 0.000 656.962 ↑ 1.1 99,942 1

Gather Merge (cost=1,000.89..159,556.70 rows=109,574 width=594) (actual time=47.442..656.962 rows=99,942 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 101.529 1,688.760 ↑ 1.4 33,314 3

Nested Loop (cost=0.86..145,909.11 rows=45,656 width=594) (actual time=20.810..562.920 rows=33,314 loops=3)

4. 45.291 1,487.289 ↑ 1.4 33,314 3

Nested Loop (cost=0.72..138,713.67 rows=45,656 width=82) (actual time=20.783..495.763 rows=33,314 loops=3)

5. 1,142.172 1,142.172 ↑ 1.4 33,314 3

Parallel Index Scan using idx_ntqm_priority on nt_queue_message (cost=0.43..120,223.63 rows=45,656 width=32) (actual time=20.736..380.724 rows=33,314 loops=3)

  • Filter: (queue_id = 36)
  • 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.40 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.003 0.042 ↑ 1.0 1 1

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

10. 0.003 0.035 ↑ 1.0 1 1

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

11. 0.002 0.027 ↑ 1.0 1 1

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

12. 0.019 0.019 ↑ 1.0 1 1

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

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

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

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

  • Index Cond: (entity_id = transmitte4_.station_id)
Planning time : 1.276 ms
Execution time : 763.723 ms