explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j7fo

Settings
# exclusive inclusive rows x rows loops node
1. 38.888 992.170 ↓ 0.0 0 1

Nested Loop (cost=1,001.31..157,124.87 rows=96,974 width=1,114) (actual time=992.170..992.170 rows=0 loops=1)

  • Functions: 65
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 13.117 ms, Inlining 0.000 ms, Optimization 3.758 ms, Emission 72.201 ms, Total 89.076 ms
2. 0.000 953.282 ↓ 1.0 99,953 1

Gather Merge (cost=1,000.89..155,651.36 rows=96,974 width=594) (actual time=68.934..953.282 rows=99,953 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 60.692 2,204.382 ↑ 1.2 33,318 3

Nested Loop (cost=0.86..143,458.13 rows=40,406 width=594) (actual time=25.811..734.794 rows=33,318 loops=3)

4. 143.727 1,943.784 ↑ 1.2 33,318 3

Nested Loop (cost=0.72..137,087.84 rows=40,406 width=82) (actual time=25.783..647.928 rows=33,318 loops=3)

5. 1,500.198 1,500.198 ↑ 1.2 33,318 3

Parallel Index Scan using idx_ntqm_priority on nt_queue_message queuemessa0_ (cost=0.43..120,223.63 rows=40,406 width=32) (actual time=25.734..500.066 rows=33,318 loops=3)

  • Filter: (queue_id = 1)
  • Rows Removed by Filter: 999421
6. 299.859 299.859 ↑ 1.0 1 99,953

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

  • Index Cond: (message_id = queuemessa0_.message_id)
7. 199.906 199.906 ↑ 1.0 1 99,953

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

  • Index Cond: (entity_id = queuemessa0_.to_entity_id)
8. 0.000 0.000 ↓ 0.0 0 99,953

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

9. 0.001 0.047 ↓ 0.0 0 1

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

10. 0.000 0.046 ↓ 0.0 0 1

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

11. 0.000 0.046 ↓ 0.0 0 1

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

12. 0.046 0.046 ↓ 0.0 0 1

Seq Scan on nt_queue queueentit2_ (cost=0.00..1.46 rows=1 width=20) (actual time=0.045..0.046 rows=0 loops=1)

  • Filter: ((queue_id = 1) AND (outbox_id = 3))
  • Rows Removed by Filter: 31
13. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_nt_outbox on nt_outbox outboxenti3_ (cost=0.14..8.16 rows=1 width=8) (never executed)

  • Index Cond: (outbox_id = 3)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_nt_transmitter on nt_transmitter transmitte4_ (cost=0.14..8.16 rows=1 width=8) (never executed)

  • Index Cond: (transmitter_id = outboxenti3_.transmitter_id)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ovs_entity on ovs_entity overseeent5_ (cost=0.14..0.84 rows=1 width=520) (never executed)

  • Index Cond: (entity_id = transmitte4_.station_id)
Planning time : 1.469 ms
Execution time : 1,007.077 ms