explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qbu2

Settings
# exclusive inclusive rows x rows loops node
1. 0.330 2,821.302 ↑ 899.7 3,483 1

Append (cost=0..1,327,620.95 rows=3,133,546 width=219) (actual time=1,826.482..2,821.302 rows=3,483 loops=1)

2. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on running_operations running_operations (cost=0..1 rows=1 width=1,113) (actual time=0.015..0.016 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
3. 2,269.609 2,269.609 ↑ 881.0 2,615 1

Index Scan using running_operations_entity_id_scheduled_time_day_idx_1 on running_operations running_operations_1 (cost=0.44..750,321.12 rows=2,303,781 width=217) (actual time=1,826.465..2,269.609 rows=2,615 loops=1)

  • Index Cond: ((scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
4. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_2 (cost=0..11.57 rows=4 width=1,113) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
5. 0.216 0.216 ↓ 0.0 0 1

Index Scan using day_running_operations_idx on running_operations running_operations_3 (cost=0.28..61.97 rows=1 width=596) (actual time=0.216..0.216 rows=0 loops=1)

  • Index Cond: (day >= ('now'::cstring)::date)
  • Filter: ((NOT frozen) AND (scheduled_time <= now()))
6. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_4 (cost=0..11.57 rows=4 width=1,113) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
7. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_5 (cost=0..1 rows=1 width=210) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
8. 0.002 0.012 ↓ 0.0 0 1

Bitmap Heap Scan on running_operations running_operations_6 (cost=1.36..2.49 rows=1 width=601) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()))
9. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on day_running_operations_idx (cost=0..1.36 rows=1 width=0) (actual time=0.01..0.01 rows=0 loops=1)

  • Index Cond: (day >= ('now'::cstring)::date)
10. 3.751 3.751 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_7 (cost=0..1,395.07 rows=1 width=230) (actual time=3.751..3.751 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
11. 0.569 0.569 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_8 (cost=0..163.61 rows=1 width=598) (actual time=0.569..0.569 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
12. 0.001 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on running_operations running_operations_9 (cost=1.24..2.36 rows=1 width=611) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()))
13. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on day_running_operations_idx (cost=0..1.24 rows=1 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (day >= ('now'::cstring)::date)
14. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_10 (cost=0..11.57 rows=4 width=1,113) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
15. 3.172 3.172 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_11 (cost=0..1,177.33 rows=50 width=258) (actual time=3.172..3.172 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
16. 25.033 25.033 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_12 (cost=0..5,387.43 rows=1,058 width=607) (actual time=25.033..25.033 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
17. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_13 (cost=0..1 rows=1 width=611) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
18. 306.875 306.875 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_14 (cost=0..85,920.1 rows=199,384 width=232) (actual time=306.875..306.875 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
19. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_15 (cost=0..12.7 rows=120 width=606) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
20. 56.281 56.281 ↑ 3,295.4 7 1

Seq Scan on running_operations running_operations_16 (cost=0..17,625.14 rows=23,068 width=229) (actual time=6.74..56.281 rows=7 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
21. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_17 (cost=0..12.7 rows=85 width=606) (actual time=0.01..0.01 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
22. 62.922 62.922 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_18 (cost=0..22,804.1 rows=26,355 width=241) (actual time=62.922..62.922 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
23. 3.663 3.663 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_19 (cost=0..1,418.37 rows=1 width=239) (actual time=3.663..3.663 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
24. 77.417 77.417 ↑ 672.6 861 1

Index Scan using running_operations_entity_id_scheduled_time_day_idx on running_operations running_operations_20 (cost=0.43..420,196.45 rows=579,150 width=221) (actual time=11.302..77.417 rows=861 loops=1)

  • Index Cond: ((scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
25. 1.408 1.408 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_21 (cost=0..440.08 rows=1 width=233) (actual time=1.408..1.408 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
26. 0.263 0.263 ↓ 0.0 0 1

Index Scan using day_running_operations_idx on running_operations running_operations_22 (cost=0.4..1,954.93 rows=32 width=616) (actual time=0.263..0.263 rows=0 loops=1)

  • Index Cond: (day >= ('now'::cstring)::date)
  • Filter: ((NOT frozen) AND (scheduled_time <= now()))
27. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_23 (cost=0..11.57 rows=4 width=1,113) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
28. 0.271 0.271 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_24 (cost=0..107.41 rows=1 width=630) (actual time=0.271..0.271 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
29. 9.405 9.405 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_25 (cost=0..2,889.01 rows=432 width=617) (actual time=9.405..9.405 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))
30. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_26 (cost=0..11.57 rows=4 width=1,113) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: ((NOT frozen) AND (scheduled_time <= now()) AND (day >= ('now'::cstring)::date))