explain.depesz.com

A tool for finding a real cause for slow queries.

Result: m4s

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 470.926 9,922.481 ↓ 1.0 890,094 1

Hash Join (cost=23,355.19..116,327.78 rows=868,674 width=16) (actual time=4,137.366..9,922.481 rows=890,094 loops=1)

  • Hash Cond: (t.dp_para_id = p.dp_para_id)
2. 5,321.187 9,389.564 ↓ 1.0 890,094 1

Bitmap Heap Scan on glt_dp_para_trend_10sec t (cost=21,681.47..97,280.58 rows=868,674 width=20) (actual time=4,074.376..9,389.564 rows=890,094 loops=1)

  • Recheck Cond: ((trend_date >= '2012-03-01 00:00:00+01'::timestamp with time zone) AND (trend_date < '2012-03-08 00:00:00+01'::timestamp with time zone))
3. 4,068.377 4,068.377 ↓ 1.0 895,972 1

Bitmap Index Scan on glt_dp_para_trend_10sec_trend_date_idx (cost=0.00..21,464.30 rows=868,674 width=0) (actual time=4,068.377..4,068.377 rows=895,972 loops=1)

  • Index Cond: ((trend_date >= '2012-03-01 00:00:00+01'::timestamp with time zone) AND (trend_date < '2012-03-08 00:00:00+01'::timestamp with time zone))
4. 3.000 61.991 ↑ 1.0 11,994 1

Hash (cost=1,523.80..1,523.80 rows=11,994 width=8) (actual time=61.991..61.991 rows=11,994 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 328kB
5. 5.999 58.991 ↑ 1.0 11,994 1

Hash Join (cost=726.68..1,523.80 rows=11,994 width=8) (actual time=21.997..58.991 rows=11,994 loops=1)

  • Hash Cond: (d.unit_id = u.unit_id)
6. 24.996 52.992 ↑ 1.0 11,994 1

Hash Join (cost=597.87..1,230.07 rows=11,994 width=12) (actual time=21.997..52.992 rows=11,994 loops=1)

  • Hash Cond: (d.dp_id = p.dp_para_id)
7. 5.999 5.999 ↑ 1.0 13,963 1

Seq Scan on glt_cfg_dp d (cost=0.00..372.63 rows=13,963 width=8) (actual time=0.000..5.999 rows=13,963 loops=1)

8. 5.000 21.997 ↑ 1.0 11,994 1

Hash (cost=447.94..447.94 rows=11,994 width=4) (actual time=21.997..21.997 rows=11,994 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 282kB
9. 16.997 16.997 ↑ 1.0 11,994 1

Seq Scan on glt_dp_para p (cost=0.00..447.94 rows=11,994 width=4) (actual time=0.000..16.997 rows=11,994 loops=1)

10. 0.000 0.000 ↑ 1.0 310 1

Hash (cost=124.94..124.94 rows=310 width=4) (actual time=0.000..0.000 rows=310 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
11. 0.000 0.000 ↑ 1.0 310 1

Hash Join (cost=1.16..124.94 rows=310 width=4) (actual time=0.000..0.000 rows=310 loops=1)

  • Hash Cond: (u.prot_type_no = x.prot_type_no)
12. 0.000 0.000 ↑ 1.0 310 1

Nested Loop (cost=0.00..119.52 rows=310 width=8) (actual time=0.000..0.000 rows=310 loops=1)

  • Join Filter: (n.node_id = u.node_id)
13. 0.000 0.000 ↑ 1.0 1 1

Nested Loop (cost=0.00..16.54 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

  • Join Filter: (n.site_id = s.site_id)
14. 0.000 0.000 ↑ 1.0 1 1

Index Scan using glt_cfg_node_pkey on glt_cfg_node n (cost=0.00..8.27 rows=1 width=8) (actual time=0.000..0.000 rows=1 loops=1)

15. 0.000 0.000 ↑ 1.0 1 1

Index Scan using glt_cfg_site_pkey on glt_cfg_site s (cost=0.00..8.27 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

16. 0.000 0.000 ↑ 1.0 310 1

Seq Scan on glt_cfg_unit u (cost=0.00..99.10 rows=310 width=12) (actual time=0.000..0.000 rows=310 loops=1)

17. 0.000 0.000 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=4) (actual time=0.000..0.000 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
18. 0.000 0.000 ↑ 1.0 7 1

Seq Scan on glt_sys_prot_type x (cost=0.00..1.07 rows=7 width=4) (actual time=0.000..0.000 rows=7 loops=1)