explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LDo8

Settings
# exclusive inclusive rows x rows loops node
1. 0.133 10,284.835 ↑ 7.3 51 1

Nested Loop Left Join (cost=128,874.71..131,990.95 rows=372 width=2,789) (actual time=10,226.922..10,284.835 rows=51 loops=1)

2. 0.097 10,284.447 ↑ 1.0 51 1

Nested Loop Left Join (cost=128,870.22..131,043.58 rows=51 width=2,706) (actual time=10,226.905..10,284.447 rows=51 loops=1)

  • Join Filter: ("systemAlert".id = "systemAlert->updates".system_alert_id)
  • Rows Removed by Join Filter: 204
3. 1.538 10,284.299 ↑ 1.0 51 1

Nested Loop Left Join (cost=128,870.22..131,031.51 rows=51 width=2,158) (actual time=10,226.877..10,284.299 rows=51 loops=1)

  • Join Filter: ("systemAlert".administrator_id = "systemAlert->administrator".id)
  • Rows Removed by Join Filter: 12903
4. 0.158 10,281.282 ↑ 1.0 51 1

Nested Loop Left Join (cost=128,870.22..130,808.81 rows=51 width=1,980) (actual time=10,226.364..10,281.282 rows=51 loops=1)

  • Join Filter: ("GlobalEventLog".system_alert_id = "systemAlert".id)
  • Rows Removed by Join Filter: 51
5. 0.146 10,279.441 ↑ 1.0 51 1

Nested Loop Left Join (cost=128,870.09..130,799.89 rows=51 width=888) (actual time=10,224.676..10,279.441 rows=51 loops=1)

6. 0.113 10,226.765 ↑ 1.0 51 1

Nested Loop Left Join (cost=128,869.66..130,372.94 rows=51 width=870) (actual time=10,224.647..10,226.765 rows=51 loops=1)

7. 0.110 10,226.142 ↑ 1.0 51 1

Nested Loop Left Join (cost=128,869.23..129,941.35 rows=51 width=833) (actual time=10,224.632..10,226.142 rows=51 loops=1)

8. 0.085 10,225.675 ↑ 1.0 51 1

Nested Loop Left Join (cost=128,868.94..129,573.29 rows=51 width=794) (actual time=10,224.618..10,225.675 rows=51 loops=1)

9. 0.103 10,225.335 ↑ 1.0 51 1

Nested Loop Left Join (cost=128,868.66..129,365.73 rows=51 width=758) (actual time=10,224.604..10,225.335 rows=51 loops=1)

10. 0.185 10,225.232 ↑ 1.0 51 1

Nested Loop Left Join (cost=128,868.52..129,244.93 rows=51 width=719) (actual time=10,224.599..10,225.232 rows=51 loops=1)

11. 0.038 10,224.639 ↑ 1.0 51 1

Limit (cost=128,868.23..128,868.36 rows=51 width=707) (actual time=10,224.549..10,224.639 rows=51 loops=1)

12. 86.570 10,224.601 ↑ 770.8 51 1

Sort (cost=128,868.23..128,966.51 rows=39,312 width=707) (actual time=10,224.546..10,224.601 rows=51 loops=1)

  • Sort Key: "GlobalEventLog".created_at DESC, "GlobalEventLog".id
  • Sort Method: top-N heapsort Memory: 71kB
13. 10,121.567 10,138.031 ↓ 1.1 41,724 1

Bitmap Heap Scan on global_event_log "GlobalEventLog" (cost=737.57..127,556.70 rows=39,312 width=707) (actual time=26.414..10,138.031 rows=41,724 loops=1)

  • Recheck Cond: ((dock_group_id = 75) AND (deleted_at IS NULL))
  • Filter: ((event_type)::text <> 'dock_created'::text)
  • Heap Blocks: exact=39194
14. 16.464 16.464 ↓ 1.1 41,724 1

Bitmap Index Scan on emergency_global_event_log_dock_group (cost=0.00..727.74 rows=39,374 width=0) (actual time=16.464..16.464 rows=41,724 loops=1)

  • Index Cond: (dock_group_id = 75)
15. 0.408 0.408 ↑ 1.0 1 51

Index Scan using dock_pkey on dock (cost=0.29..7.36 rows=1 width=12) (actual time=0.007..0.008 rows=1 loops=51)

  • Index Cond: ("GlobalEventLog".dock_id = id)
  • Filter: (deleted_at IS NULL)
16. 0.000 0.000 ↓ 0.0 0 51

Index Scan using administrator_pkey on administrator (cost=0.14..2.36 rows=1 width=39) (actual time=0.000..0.000 rows=0 loops=51)

  • Index Cond: ("GlobalEventLog".administrator_id = id)
  • Filter: (deleted_at IS NULL)
17. 0.255 0.255 ↑ 1.0 1 51

Index Scan using dock_group_pkey on dock_group "dockGroup" (cost=0.28..4.06 rows=1 width=36) (actual time=0.004..0.005 rows=1 loops=51)

  • Index Cond: ("GlobalEventLog".dock_group_id = id)
  • Filter: (deleted_at IS NULL)
18. 0.357 0.357 ↑ 1.0 1 51

Index Scan using vehicle_pkey on vehicle (cost=0.29..7.21 rows=1 width=39) (actual time=0.007..0.007 rows=1 loops=51)

  • Index Cond: ("GlobalEventLog".vehicle_id = id)
  • Filter: (deleted_at IS NULL)
19. 0.510 0.510 ↑ 1.0 1 51

Index Scan using trip_pkey on trip (cost=0.43..8.45 rows=1 width=37) (actual time=0.010..0.010 rows=1 loops=51)

  • Index Cond: ("GlobalEventLog".trip_id = id)
  • Filter: (deleted_at IS NULL)
20. 52.530 52.530 ↑ 1.0 1 51

Index Scan using subscriber_pkey on "user" (cost=0.42..8.36 rows=1 width=18) (actual time=1.016..1.030 rows=1 loops=51)

  • Index Cond: ("GlobalEventLog".user_id = id)
  • Filter: (deleted_at IS NULL)
21. 0.026 1.683 ↑ 1.0 1 51

Materialize (cost=0.14..8.15 rows=1 width=1,092) (actual time=0.033..0.033 rows=1 loops=51)

22. 1.657 1.657 ↑ 1.0 1 1

Index Scan using "System ID and incident start time decreasing" on system_alert "systemAlert" (cost=0.14..8.15 rows=1 width=1,092) (actual time=1.656..1.657 rows=1 loops=1)

23. 1.135 1.479 ↑ 1.0 253 51

Materialize (cost=0.00..29.80 rows=253 width=178) (actual time=0.001..0.029 rows=253 loops=51)

24. 0.344 0.344 ↑ 1.0 253 1

Seq Scan on administrator "systemAlert->administrator" (cost=0.00..28.53 rows=253 width=178) (actual time=0.019..0.344 rows=253 loops=1)

  • Filter: (deleted_at IS NULL)
25. 0.035 0.051 ↓ 4.0 4 51

Materialize (cost=0.00..11.31 rows=1 width=548) (actual time=0.001..0.001 rows=4 loops=51)

26. 0.016 0.016 ↓ 4.0 4 1

Seq Scan on system_alert_update "systemAlert->updates" (cost=0.00..11.30 rows=1 width=548) (actual time=0.016..0.016 rows=4 loops=1)

  • Filter: (deleted_at IS NULL)
27. 0.153 0.255 ↓ 0.0 0 51

Nested Loop (cost=4.49..18.51 rows=7 width=63) (actual time=0.005..0.005 rows=0 loops=51)

28. 0.051 0.102 ↓ 0.0 0 51

Bitmap Heap Scan on system_alert_dock_group "systemAlert->dockGroups->SystemAlertDockGroup" (cost=4.21..14.37 rows=8 width=20) (actual time=0.002..0.002 rows=0 loops=51)

  • Recheck Cond: ("systemAlert".id = system_alert_id)
29. 0.051 0.051 ↓ 0.0 0 51

Bitmap Index Scan on system_alert_dock_group_system_alert_id_dock_group_id_pk (cost=0.00..4.21 rows=8 width=0) (actual time=0.001..0.001 rows=0 loops=51)

  • Index Cond: ("systemAlert".id = system_alert_id)
30. 0.000 0.000 ↓ 0.0 0

Index Scan using dock_group_pkey on dock_group "systemAlert->dockGroups" (cost=0.28..0.51 rows=1 width=43) (never executed)

  • Index Cond: (id = "systemAlert->dockGroups->SystemAlertDockGroup".dock_group_id)
  • Filter: (deleted_at IS NULL)
Planning time : 3.934 ms
Execution time : 10,285.456 ms