explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rs3P

Settings
# exclusive inclusive rows x rows loops node
1. 3.696 283.955 ↑ 1.6 5,350 1

Nested Loop (cost=1,432.53..20,464.75 rows=8,559 width=1,435) (actual time=15.867..283.955 rows=5,350 loops=1)

2. 1.303 10.619 ↓ 1.1 535 1

HashAggregate (cost=1,432.11..1,436.96 rows=485 width=8) (actual time=10.493..10.619 rows=535 loops=1)

  • Group Key: lightcurve_revisions_1.tic_id
3. 0.534 9.316 ↑ 1.0 4,755 1

Limit (cost=0.00..1,372.67 rows=4,755 width=8) (actual time=0.017..9.316 rows=4,755 loops=1)

4. 8.782 8.782 ↑ 58.8 4,755 1

Seq Scan on lightcurve_revisions lightcurve_revisions_1 (cost=0.00..80,745.05 rows=279,705 width=8) (actual time=0.014..8.782 rows=4,755 loops=1)

5. 269.640 269.640 ↑ 1.0 10 535

Index Scan using ix_lightcurve_revisions_tic_id on lightcurve_revisions (cost=0.42..39.13 rows=10 width=1,435) (actual time=0.486..0.504 rows=10 loops=535)

  • Index Cond: (tic_id = lightcurve_revisions_1.tic_id)