explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X0y5

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 283.860 ↑ 1.0 1 1

Aggregate (cost=7,775.07..7,775.08 rows=1 width=0) (actual time=283.860..283.860 rows=1 loops=1)

2. 1.074 283.839 ↓ 16.7 100 1

Hash Join (cost=1,684.17..7,775.05 rows=6 width=0) (actual time=282.781..283.839 rows=100 loops=1)

  • Hash Cond: (node_parents.nid = all_devices_emon_status_data.nid)
3. 232.149 232.149 ↓ 4.2 100 1

Seq Scan on node_parents (cost=0.00..6,066.36 rows=24 width=16) (actual time=232.040..232.149 rows=100 loops=1)

  • Filter: ((parent_nid)::text ~~* '%6589a325-de9e-44b1-84ee-0b2023093d13%'::text)
  • Rows Removed by Filter: 243364
4. 2.175 50.616 ↓ 1.9 5,390 1

Hash (cost=1,635.23..1,635.23 rows=2,795 width=16) (actual time=50.616..50.616 rows=5,390 loops=1)

  • Buckets: 1024 Batches: 4 (originally 2) Memory Usage: 65kB
5. 2.470 48.441 ↓ 1.9 5,390 1

Subquery Scan on all_devices_emon_status_data (cost=1,027.32..1,635.23 rows=2,795 width=16) (actual time=30.823..48.441 rows=5,390 loops=1)

6. 11.680 45.971 ↓ 1.9 5,390 1

Unique (cost=1,027.32..1,607.28 rows=2,795 width=153) (actual time=30.822..45.971 rows=5,390 loops=1)

7. 24.715 34.291 ↓ 1.9 5,390 1

Sort (cost=1,027.32..1,034.31 rows=2,795 width=153) (actual time=30.820..34.291 rows=5,390 loops=1)

  • Sort Key: "*SELECT* 1".endpoint_id, "*SELECT* 1".ipaddress, "*SELECT* 1".lastcontactedon, "*SELECT* 1".syncedon, "*SELECT* 1".user_name, "*SELECT* 1".d
  • Sort Method: external merge Disk: 808kB
8. 1.967 9.576 ↓ 1.9 5,390 1

Append (cost=5.38..650.33 rows=2,795 width=153) (actual time=0.140..9.576 rows=5,390 loops=1)

9. 0.116 0.602 ↑ 1.0 150 1

Subquery Scan on *SELECT* 1 (cost=5.38..29.44 rows=150 width=2,329) (actual time=0.138..0.602 rows=150 loops=1)

10. 0.251 0.486 ↑ 1.0 150 1

Hash Join (cost=5.38..27.94 rows=150 width=2,329) (actual time=0.137..0.486 rows=150 loops=1)

  • Hash Cond: (w.endpoint_id = f.endpoint_id)
11. 0.125 0.125 ↑ 1.0 150 1

Seq Scan on emon_status_wide_data w (cost=0.00..20.50 rows=150 width=2,297) (actual time=0.002..0.125 rows=150 loops=1)

12. 0.058 0.110 ↑ 1.0 150 1

Hash (cost=3.50..3.50 rows=150 width=36) (actual time=0.110..0.110 rows=150 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
13. 0.052 0.052 ↑ 1.0 150 1

Seq Scan on emon_frequent_data f (cost=0.00..3.50 rows=150 width=36) (actual time=0.006..0.052 rows=150 loops=1)

14. 6.781 7.007 ↓ 2.0 5,240 1

Seq Scan on device (cost=28.31..594.44 rows=2,645 width=30) (actual time=0.317..7.007 rows=5,240 loops=1)

  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 150
15.          

SubPlan (for Seq Scan)

16. 0.099 0.226 ↑ 1.0 150 1

Hash Join (cost=5.38..27.94 rows=150 width=16) (actual time=0.100..0.226 rows=150 loops=1)

  • Hash Cond: (w.endpoint_id = f.endpoint_id)
17. 0.039 0.039 ↑ 1.0 150 1

Seq Scan on emon_status_wide_data w (cost=0.00..20.50 rows=150 width=20) (actual time=0.001..0.039 rows=150 loops=1)

18. 0.048 0.088 ↑ 1.0 150 1

Hash (cost=3.50..3.50 rows=150 width=4) (actual time=0.088..0.088 rows=150 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
19. 0.040 0.040 ↑ 1.0 150 1

Seq Scan on emon_frequent_data f (cost=0.00..3.50 rows=150 width=4) (actual time=0.004..0.040 rows=150 loops=1)