explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RtEJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=2,139.08..2,139.09 rows=1 width=16) (actual rows= loops=)

  • SQL Hash: -971657230, Plan Hash: -1322567591
2.          

Initplan (for Aggregate)

3. 0.000 0.000 ↓ 0.0

Aggregate (cost=698.96..698.97 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on pgbench_history mn (cost=0.00..679.17 rows=7,917 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Aggregate (cost=698.96..698.97 rows=1 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on pgbench_history mx (cost=0.00..679.17 rows=7,917 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.14..741.13 rows=1 width=8) (actual rows= loops=)

  • Join Filter: (h.bid = b.bid)
8. 0.000 0.000 ↓ 0.0

Index Scan using pgbench_branches_pkey on pgbench_branches b (cost=0.14..20.47 rows=3 width=8) (actual rows= loops=)

  • Index Cond: (bid = ANY ('{1,2,3}'::integer[]))
9. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..718.96 rows=40 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on pgbench_history h (cost=0.00..718.75 rows=40 width=8) (actual rows= loops=)

  • Filter: ((mtime >= $0) AND (mtime <= $1))