explain.depesz.com

PostgreSQL's explain analyze made readable

Result: urJ2

Settings
# exclusive inclusive rows x rows loops node
1. 1.206 3,654.166 ↑ 246.7 12,723 1

Append (cost=0..1,329,023.32 rows=3,138,211 width=12) (actual time=2,646.538..3,654.166 rows=12,723 loops=1)

  • Buffers: shared hit=122110
2. 0.015 0.015 ↓ 0.0 0 1

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

  • Filter: ((NOT running_operations.frozen) AND (running_operations.scheduled_time <= now()) AND (running_operations.day >= ('now'::cstring)::date))
  • Buffers: shared hit=1
3. 3,088.603 3,088.603 ↑ 194.6 11,865 1

Index Scan using running_operations_entity_id_scheduled_time_day_idx_1 on running_operations running_operations_1 (cost=0.44..751,700.14 rows=2,308,445 width=12) (actual time=2,646.521..3,088.603 rows=11,865 loops=1)

  • Index Cond: ((running_operations_1.scheduled_time <= now()) AND (running_operations_1.day >= ('now'::cstring)::date))
  • Buffers: shared hit=33907
4. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_2 (cost=0..11.57 rows=4 width=12) (actual time=0.018..0.018 rows=0 loops=1)

  • Filter: ((NOT running_operations_2.frozen) AND (running_operations_2.scheduled_time <= now()) AND (running_operations_2.day >= ('now'::cstring)::date))
5. 0.239 0.239 ↓ 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=12) (actual time=0.239..0.239 rows=0 loops=1)

  • Index Cond: (running_operations_3.day >= ('now'::cstring)::date)
  • Filter: ((NOT running_operations_3.frozen) AND (running_operations_3.scheduled_time <= now()))
  • Buffers: shared hit=190
6. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_4 (cost=0..11.57 rows=4 width=12) (actual time=0.005..0.005 rows=0 loops=1)

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

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

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

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

  • Filter: ((NOT running_operations_6.frozen) AND (running_operations_6.scheduled_time <= now()))
  • Buffers: shared hit=3
9. 0.011 0.011 ↓ 0.0 0 1

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

  • Index Cond: (running_operations_6.day >= ('now'::cstring)::date)
  • Buffers: shared hit=3
10. 3.753 3.753 ↓ 0.0 0 1

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

  • Filter: ((NOT running_operations_7.frozen) AND (running_operations_7.scheduled_time <= now()) AND (running_operations_7.day >= ('now'::cstring)::date))
  • Buffers: shared hit=909
11. 0.641 0.641 ↓ 0.0 0 1

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

  • Filter: ((NOT running_operations_8.frozen) AND (running_operations_8.scheduled_time <= now()) AND (running_operations_8.day >= ('now'::cstring)::date))
  • Buffers: shared hit=125
12. 0.002 0.017 ↓ 0.0 0 1

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

  • Filter: ((NOT running_operations_9.frozen) AND (running_operations_9.scheduled_time <= now()))
  • Buffers: shared hit=1
13. 0.015 0.015 ↓ 0.0 0 1

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

  • Index Cond: (running_operations_9.day >= ('now'::cstring)::date)
  • Buffers: shared hit=1
14. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_10 (cost=0..11.57 rows=4 width=12) (actual time=0.005..0.005 rows=0 loops=1)

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

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

  • Filter: ((NOT running_operations_11.frozen) AND (running_operations_11.scheduled_time <= now()) AND (running_operations_11.day >= ('now'::cstring)::date))
  • Buffers: shared hit=744
16. 26.314 26.314 ↓ 0.0 0 1

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

  • Filter: ((NOT running_operations_12.frozen) AND (running_operations_12.scheduled_time <= now()) AND (running_operations_12.day >= ('now'::cstring)::date))
  • Buffers: shared hit=2888
17. 0.015 0.015 ↓ 0.0 0 1

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

  • Filter: ((NOT running_operations_13.frozen) AND (running_operations_13.scheduled_time <= now()) AND (running_operations_13.day >= ('now'::cstring)::date))
  • Buffers: shared hit=1
18. 298.769 298.769 ↓ 0.0 0 1

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

  • Filter: ((NOT running_operations_14.frozen) AND (running_operations_14.scheduled_time <= now()) AND (running_operations_14.day >= ('now'::cstring)::date))
  • Buffers: shared hit=51649
19. 0.011 0.011 ↓ 0.0 0 1

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

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

Seq Scan on running_operations running_operations_16 (cost=0..17,625.14 rows=23,068 width=12) (actual time=58.602..58.602 rows=0 loops=1)

  • Filter: ((NOT running_operations_16.frozen) AND (running_operations_16.scheduled_time <= now()) AND (running_operations_16.day >= ('now'::cstring)::date))
  • Buffers: shared hit=11188
21. 0.013 0.013 ↓ 0.0 0 1

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

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

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

  • Filter: ((NOT running_operations_18.frozen) AND (running_operations_18.scheduled_time <= now()) AND (running_operations_18.day >= ('now'::cstring)::date))
  • Buffers: shared hit=13069
23. 4.526 4.526 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_19 (cost=0..1,418.37 rows=1 width=12) (actual time=4.525..4.526 rows=0 loops=1)

  • Filter: ((NOT running_operations_19.frozen) AND (running_operations_19.scheduled_time <= now()) AND (running_operations_19.day >= ('now'::cstring)::date))
  • Buffers: shared hit=908
24. 84.603 84.603 ↑ 675.0 858 1

Index Scan using running_operations_entity_id_scheduled_time_day_idx on running_operations running_operations_20 (cost=0.43..420,196.46 rows=579,151 width=12) (actual time=12.762..84.603 rows=858 loops=1)

  • Index Cond: ((running_operations_20.scheduled_time <= now()) AND (running_operations_20.day >= ('now'::cstring)::date))
  • Buffers: shared hit=4352
25. 1.402 1.402 ↓ 0.0 0 1

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

  • Filter: ((NOT running_operations_21.frozen) AND (running_operations_21.scheduled_time <= now()) AND (running_operations_21.day >= ('now'::cstring)::date))
  • Buffers: shared hit=284
26. 0.274 0.274 ↓ 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=12) (actual time=0.274..0.274 rows=0 loops=1)

  • Index Cond: (running_operations_22.day >= ('now'::cstring)::date)
  • Filter: ((NOT running_operations_22.frozen) AND (running_operations_22.scheduled_time <= now()))
  • Buffers: shared hit=243
27. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_23 (cost=0..11.57 rows=4 width=12) (actual time=0.007..0.007 rows=0 loops=1)

  • Filter: ((NOT running_operations_23.frozen) AND (running_operations_23.scheduled_time <= now()) AND (running_operations_23.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=12) (actual time=0.271..0.271 rows=0 loops=1)

  • Filter: ((NOT running_operations_24.frozen) AND (running_operations_24.scheduled_time <= now()) AND (running_operations_24.day >= ('now'::cstring)::date))
  • Buffers: shared hit=60
29. 8.609 8.609 ↓ 0.0 0 1

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

  • Filter: ((NOT running_operations_25.frozen) AND (running_operations_25.scheduled_time <= now()) AND (running_operations_25.day >= ('now'::cstring)::date))
  • Buffers: shared hit=1587
30. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on running_operations running_operations_26 (cost=0..11.57 rows=4 width=12) (actual time=0.01..0.01 rows=0 loops=1)

  • Filter: ((NOT running_operations_26.frozen) AND (running_operations_26.scheduled_time <= now()) AND (running_operations_26.day >= ('now'::cstring)::date))
Planning time : 3.112 ms
Execution time : 3,688.551 ms