explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pylp

Settings
# exclusive inclusive rows x rows loops node
1. 13.859 37.498 ↓ 16.2 21,948 1

Sort (cost=19,744.81..19,748.20 rows=1,354 width=12) (actual time=32.667..37.498 rows=21,948 loops=1)

  • Sort Key: people_tags.id
  • Sort Method: quicksort Memory: 1797kB
  • Planning time: 0.220 ms
  • Execution time: 41.433 ms
2. 9.026 23.639 ↓ 16.2 21,948 1

Nested Loop (cost=0.72..19,674.38 rows=1,354 width=12) (actual time=0.020..23.639 rows=21,948 loops=1)

3. 0.014 0.014 ↓ 3.2 13 1

Index Scan using index_tags_on_project_id on tags (cost=0.29..17.80 rows=4 width=4) (actual time=0.006..0.014 rows=13 loops=1)

  • Index Cond: (project_id = 2)
4. 14.599 14.599 ↑ 1.1 1,688 13

Index Scan using index_people_tags_on_tag_id_and_person_id on people_tags (cost=0.43..4,895.65 rows=1,850 width=12) (actual time=0.006..1.123 rows=1,688 loops=13)

  • Index Cond: (tag_id = tags.id)