explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 77ev

Settings
# exclusive inclusive rows x rows loops node
1. 2,172.017 11,702.951 ↓ 41.9 47,256 1

Seq Scan on pingdata p1 (cost=0.00..1,210,657.13 rows=1,128 width=108) (actual time=0.701..11,702.951 rows=47,256 loops=1)

  • Filter: (hopnum = (SubPlan 2))
  • Rows Removed by Filter: 179,671
2.          

SubPlan (for Seq Scan)

3. 3,176.978 9,530.934 ↑ 1.0 1 226,927

Result (cost=5.32..5.33 rows=1 width=4) (actual time=0.039..0.042 rows=1 loops=226,927)

4.          

Initplan (for Result)

5. 2,723.124 6,353.956 ↑ 1.0 1 226,927

Limit (cost=0.42..5.32 rows=1 width=4) (actual time=0.025..0.028 rows=1 loops=226,927)

6. 3,630.832 3,630.832 ↑ 2.0 1 226,927

Index Only Scan Backward using pingdata_pkey on pingdata p2 (cost=0.42..10.23 rows=2 width=4) (actual time=0.016..0.016 rows=1 loops=226,927)

  • Index Cond: ((starttime = p1.starttime) AND (pinghost = (p1.pinghost)::text) AND (target = (p1.target)::text) AND (proto = (p1.proto)::text) AND (hopnum IS NOT NULL))
  • Heap Fetches: 226,927
Planning time : 0.531 ms
Execution time : 11,857.947 ms