explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5zHS

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 1,076.486 ↑ 4,742.5 4 1

Hash Join (cost=99,752.24..118,382.64 rows=18,970 width=79) (actual time=1,051.124..1,076.486 rows=4 loops=1)

  • Hash Cond: ((pg.currency_name)::text = (c.name)::text)
2. 27.663 1,076.393 ↑ 2,725.1 7 1

Hash Join (cost=99,746.75..118,115.92 rows=19,076 width=75) (actual time=1,051.038..1,076.393 rows=7 loops=1)

  • Hash Cond: (r.playergame_id = pg.id)
3. 12.702 430.068 ↑ 2,725.1 7 1

Hash Join (cost=42,692.12..49,082.99 rows=19,076 width=40) (actual time=418.572..430.068 rows=7 loops=1)

  • Hash Cond: (r.gameplay_id = gp.id)
4. 0.082 0.082 ↑ 2,725.1 7 1

Index Scan using ix_app_round_pr_pg_gp_exceed_finished on app_round r (cost=0.25..55.83 rows=19,076 width=40) (actual time=0.032..0.082 rows=7 loops=1)

  • Index Cond: ((project_id = 21) AND (is_exceed = false) AND (finished = false))
  • Filter: ((c_at <= '2018-09-23 00:00:00+00'::timestamp with time zone) AND (c_at >= '2018-08-21 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 9
5. 228.263 417.284 ↑ 1.0 1,181,409 1

Hash (cost=22,141.72..22,141.72 rows=1,182,172 width=16) (actual time=417.284..417.284 rows=1,181,409 loops=1)

  • Buckets: 32768 Batches: 128 Memory Usage: 625kB
6. 189.021 189.021 ↑ 1.0 1,181,409 1

Seq Scan on app_gameplay gp (cost=0.00..22,141.72 rows=1,182,172 width=16) (actual time=0.008..189.021 rows=1,181,409 loops=1)

7. 376.683 618.662 ↑ 1.0 1,168,470 1

Hash (cost=31,027.17..31,027.17 rows=1,168,917 width=51) (actual time=618.662..618.662 rows=1,168,470 loops=1)

  • Buckets: 16384 Batches: 128 Memory Usage: 907kB
8. 241.979 241.979 ↑ 1.0 1,168,470 1

Seq Scan on app_playergame pg (cost=0.00..31,027.17 rows=1,168,917 width=51) (actual time=0.019..241.979 rows=1,168,470 loops=1)

9. 0.030 0.069 ↑ 1.0 179 1

Hash (cost=3.25..3.25 rows=179 width=8) (actual time=0.069..0.069 rows=179 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
10. 0.039 0.039 ↑ 1.0 179 1

Seq Scan on core_currency c (cost=0.00..3.25 rows=179 width=8) (actual time=0.007..0.039 rows=179 loops=1)

  • Filter: ((type)::text = 'real'::text)
  • Rows Removed by Filter: 1