explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QeUJ : max

Settings
# exclusive inclusive rows x rows loops node
1. 2,629.528 7,757.429 ↓ 399.0 141,262 1

Hash Join (cost=6.97..120.08 rows=354 width=1,293) (actual time=0.73..7,757.429 rows=141,262 loops=1)

  • Buffers: shared hit=47,536
2. 2,852.463 5,127.682 ↓ 399.0 141,262 1

Nested Loop (cost=5.75..113.99 rows=354 width=1,229) (actual time=0.476..5,127.682 rows=141,262 loops=1)

  • Buffers: shared hit=47,535
3. 336.020 751.699 ↓ 330.6 15,870 1

Nested Loop (cost=5.46..74.5 rows=48 width=1,209) (actual time=0.434..751.699 rows=15,870 loops=1)

  • Buffers: shared hit=14,926
4. 57.632 229.136 ↓ 329.0 2,303 1

Nested Loop (cost=5.17..66.15 rows=7 width=643) (actual time=0.329..229.136 rows=2,303 loops=1)

  • Buffers: shared hit=7,814
5. 26.296 137.022 ↓ 273.7 821 1

Nested Loop (cost=4.88..64.36 rows=3 width=607) (actual time=0.286..137.022 rows=821 loops=1)

  • Buffers: shared hit=5,413
6. 20.908 94.166 ↓ 184.0 552 1

Nested Loop (cost=4.6..63.16 rows=3 width=571) (actual time=0.244..94.166 rows=552 loops=1)

  • Buffers: shared hit=3,758
7. 33.026 60.010 ↓ 184.0 552 1

Nested Loop (cost=4.47..62.67 rows=3 width=289) (actual time=0.205..60.01 rows=552 loops=1)

  • Buffers: shared hit=2,654
8. 8.348 8.482 ↓ 168.2 841 1

Bitmap Heap Scan on locations l (cost=4.19..21.12 rows=5 width=177) (actual time=0.159..8.482 rows=841 loops=1)

  • Heap Blocks: exact=115
  • Buffers: shared hit=125
9. 0.134 0.134 ↓ 168.2 841 1

Bitmap Index Scan on locations_point_idx (cost=0..4.18 rows=5 width=0) (actual time=0.126..0.134 rows=841 loops=1)

  • Index Cond: (l.point <@ '(37.9329689999999999,55.9328860000000034),(37.2985090000000028,55.5587689999999981)'::box)
  • Buffers: shared hit=10
10. 18.502 18.502 ↑ 1.0 1 841

Index Scan using atms_pkey on atms a (cost=0.28..8.3 rows=1 width=112) (actual time=0.016..0.022 rows=1 loops=841)

  • Index Cond: (a.uuid = l.atms_uuid)
  • Filter: (NOT a.private)
  • Buffers: shared hit=2,529
11. 13.248 13.248 ↑ 1.0 1 552

Index Scan using banks_pkey on banks b (cost=0.13..0.15 rows=1 width=282) (actual time=0.014..0.024 rows=1 loops=552)

  • Index Cond: (b.id = a.banks_id)
  • Buffers: shared hit=1,104
12. 16.560 16.560 ↑ 1.0 1 552

Index Scan using cash_out_atms_uuid_idx on cash_out co (cost=0.28..0.39 rows=1 width=36) (actual time=0.015..0.03 rows=1 loops=552)

  • Index Cond: (a.uuid = co.atms_uuid)
  • Buffers: shared hit=1,655
13. 34.482 34.482 ↑ 1.0 3 821

Index Scan using cash_in_atms_uuid_idx on cash_in ci (cost=0.29..0.57 rows=3 width=36) (actual time=0.015..0.042 rows=3 loops=821)

  • Index Cond: (a.uuid = ci.atms_uuid)
  • Buffers: shared hit=2,401
14. 186.543 186.543 ↑ 1.0 7 2,303

Index Scan using working_times_atms_uuid_idx on working_times wt (cost=0.29..1.12 rows=7 width=566) (actual time=0.014..0.081 rows=7 loops=2,303)

  • Index Cond: (wt.atms_uuid = a.uuid)
  • Buffers: shared hit=7,112
15. 1,523.520 1,523.520 ↓ 1.3 9 15,870

Index Only Scan using atms_functions_pkey on atms_functions af (cost=0.29..0.75 rows=7 width=20) (actual time=0.013..0.096 rows=9 loops=15,870)

  • Index Cond: (af.atms_uuid = a.uuid)
  • Buffers: shared hit=32,609
16. 0.106 0.219 ↑ 1.0 10 1

Hash (cost=1.1..1.1 rows=10 width=64) (actual time=0.211..0.219 rows=10 loops=1)

  • Buffers: shared hit=1
17. 0.113 0.113 ↑ 1.0 10 1

Seq Scan on functions f (cost=0..1.1 rows=10 width=64) (actual time=0.014..0.113 rows=10 loops=1)

  • Buffers: shared hit=1
Planning time : 3.088 ms
Execution time : 9,012.558 ms