explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5aU

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 3,753,633.277 ↑ 1.0 1 1

Limit (cost=42.30..44,854.24 rows=1 width=1,453) (actual time=3,753,633.277..3,753,633.277 rows=1 loops=1)

2. 1,810,988.670 3,753,633.276 ↑ 231,841.0 1 1

Index Scan using cash_hand_histories_primary_key on cash_hand_histories a (cost=42.30..10,389,245,344.03 rows=231,841 width=1,453) (actual time=3,753,633.276..3,753,633.276 rows=1 loops=1)

  • Filter: ((history ~~ 'Game started at: %'::text) AND (NOT (hashed SubPlan 2)) AND (NOT (SubPlan 1)))
  • Rows Removed by Filter: 161703
3.          

SubPlan (forIndex Scan)

4. 0.030 0.030 ↑ 182.1 14 1

Seq Scan on failed_hands i_1 (cost=0.00..35.50 rows=2,550 width=4) (actual time=0.030..0.030 rows=14 loops=1)

5. 1,942,385.252 1,942,644.576 ↑ 2.0 236,463 149,988

Materialize (cost=0.00..17,145.81 rows=474,321 width=4) (actual time=0.011..12.952 rows=236,463 loops=149,988)

6. 259.324 259.324 ↑ 1.0 474,321 1

Seq Scan on preflop_start_actions i (cost=0.00..12,921.21 rows=474,321 width=4) (actual time=0.013..259.324 rows=474,321 loops=1)