explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0Z5

Settings
# exclusive inclusive rows x rows loops node
1. 5.055 2,942.724 ↑ 70.1 45,586 1

Append (cost=0..1,329,871.42 rows=3,196,821 width=220) (actual time=2,002.122..2,942.724 rows=45,586 loops=1)

  • Buffers: shared hit=163116 read=6 dirtied=130
2. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on running_operations g (cost=0..1.16 rows=1 width=1,113) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: ((NOT g.frozen) AND (g.scheduled_time <= now()) AND (g.day >= ('now'::cstring)::date))
  • Buffers: shared hit=1
3. 2,363.913 2,363.913 ↑ 53.7 43,991 1

Index Scan using running_operations_entity_id_scheduled_time_day_idx_1 on running_operations g_1 (cost=0.44..749,047.84 rows=2,362,894 width=218) (actual time=2,002.105..2,363.913 rows=43,991 loops=1)

  • Index Cond: ((g_1.scheduled_time <= now()) AND (g_1.day >= ('now'::cstring)::date))
  • Buffers: shared hit=74443 dirtied=130
4. 0.010 0.010 ↓ 0.0 0 1

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

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

Index Scan using day_running_operations_idx on running_operations g_3 (cost=0.28..62.23 rows=1 width=596) (actual time=3.696..3.696 rows=0 loops=1)

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

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

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

Seq Scan on running_operations g_5 (cost=0..2 rows=1 width=214) (actual time=0.008..0.008 rows=0 loops=1)

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

Seq Scan on running_operations g_6 (cost=0..14.31 rows=14 width=601) (actual time=0.021..0.021 rows=0 loops=1)

  • Filter: ((NOT g_6.frozen) AND (g_6.scheduled_time <= now()) AND (g_6.day >= ('now'::cstring)::date))
  • Buffers: shared hit=14
9. 5.214 5.214 ↓ 0.0 0 1

Seq Scan on running_operations g_7 (cost=0..1,404.63 rows=397 width=229) (actual time=5.214..5.214 rows=0 loops=1)

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

Seq Scan on running_operations g_8 (cost=0..163.95 rows=1 width=598) (actual time=0.723..0.723 rows=0 loops=1)

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

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

  • Filter: ((NOT g_9.frozen) AND (g_9.scheduled_time <= now()))
  • Buffers: shared hit=1
12. 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: (g_9.day >= ('now'::cstring)::date)
  • Buffers: shared hit=1
13. 0.006 0.006 ↓ 0.0 0 1

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

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

Seq Scan on running_operations g_11 (cost=0..1,177.33 rows=51 width=258) (actual time=7.933..7.933 rows=0 loops=1)

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

Seq Scan on running_operations g_12 (cost=0..5,355.37 rows=11 width=607) (actual time=26.954..26.954 rows=0 loops=1)

  • Filter: ((NOT g_12.frozen) AND (g_12.scheduled_time <= now()) AND (g_12.day >= ('now'::cstring)::date))
  • Buffers: shared hit=2888
16. 0.061 0.061 ↑ 14.9 8 1

Seq Scan on running_operations g_13 (cost=0..12.7 rows=119 width=607) (actual time=0.055..0.061 rows=8 loops=1)

  • Filter: ((NOT g_13.frozen) AND (g_13.scheduled_time <= now()) AND (g_13.day >= ('now'::cstring)::date))
  • Buffers: shared hit=1
17. 292.161 292.161 ↑ 2,425.2 76 1

Seq Scan on running_operations g_14 (cost=0..82,403.42 rows=184,316 width=232) (actual time=141.695..292.161 rows=76 loops=1)

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

Bitmap Heap Scan on running_operations g_15 (cost=1.24..2.36 rows=1 width=614) (actual time=0.034..0.034 rows=0 loops=1)

  • Filter: ((NOT g_15.frozen) AND (g_15.scheduled_time <= now()))
  • Buffers: shared hit=1
19. 0.032 0.032 ↓ 0.0 0 1

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

  • Index Cond: (g_15.day >= ('now'::cstring)::date)
  • Buffers: shared hit=1
20. 56.611 56.611 ↓ 0.0 0 1

Seq Scan on running_operations g_16 (cost=0..17,627.59 rows=23,225 width=226) (actual time=56.611..56.611 rows=0 loops=1)

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

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

  • Filter: ((NOT g_17.frozen) AND (g_17.scheduled_time <= now()) AND (g_17.day >= ('now'::cstring)::date))
22. 75.837 75.837 ↑ 106.5 264 1

Seq Scan on running_operations g_18 (cost=0..22,843.27 rows=28,126 width=241) (actual time=50.717..75.837 rows=264 loops=1)

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

Seq Scan on running_operations g_19 (cost=0..1,418.23 rows=1 width=239) (actual time=4.541..4.541 rows=0 loops=1)

  • Filter: ((NOT g_19.frozen) AND (g_19.scheduled_time <= now()) AND (g_19.day >= ('now'::cstring)::date))
  • Buffers: shared hit=908
24. 87.204 87.204 ↑ 478.8 1,247 1

Index Scan using running_operations_entity_id_scheduled_time_day_idx on running_operations g_20 (cost=0.43..426,926.93 rows=597,027 width=221) (actual time=12.798..87.204 rows=1,247 loops=1)

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

Seq Scan on running_operations g_21 (cost=0..447.55 rows=1 width=233) (actual time=1.684..1.684 rows=0 loops=1)

  • Filter: ((NOT g_21.frozen) AND (g_21.scheduled_time <= now()) AND (g_21.day >= ('now'::cstring)::date))
  • Buffers: shared hit=284
26. 0.301 0.301 ↓ 0.0 0 1

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

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

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

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

Seq Scan on running_operations g_24 (cost=0..103.35 rows=1 width=630) (actual time=0.4..0.4 rows=0 loops=1)

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

Seq Scan on running_operations g_25 (cost=0..2,845.22 rows=494 width=617) (actual time=10.297..10.297 rows=0 loops=1)

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

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

  • Filter: ((NOT g_26.frozen) AND (g_26.scheduled_time <= now()) AND (g_26.day >= ('now'::cstring)::date))
Planning time : 2.909 ms
Execution time : 2,962.291 ms