explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wDf

Settings
# exclusive inclusive rows x rows loops node
1. 13.912 37.484 ↓ 16.2 21,948 1

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

  • Sort Key: people_tags.id
  • Sort Method: quicksort Memory: 1797kB
  • Planning time: 0.221 ms
  • Execution time: 41.507 ms
2. 9.136 23.572 ↓ 16.2 21,948 1

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

3. 0.019 0.019 ↓ 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.019 rows=13 loops=1)

  • Index Cond: (project_id = 2)
4. 14.417 14.417 ↑ 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.109 rows=1,688 loops=13)

  • Index Cond: (tag_id = tags.id)