explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pmbE

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 29,139.105 ↑ 1.0 20 1

Limit (cost=12,403.14..12,403.19 rows=20 width=211) (actual time=29,139.097..29,139.105 rows=20 loops=1)

2. 31.899 29,139.099 ↑ 433.3 20 1

Sort (cost=12,403.14..12,424.81 rows=8,666 width=211) (actual time=29,139.095..29,139.099 rows=20 loops=1)

  • Sort Key: id DESC
  • Sort Method: top-N heapsort Memory: 35kB
3. 29,107.200 29,107.200 ↓ 5.2 44,789 1

Index Scan using index_audit_events_on_entity_id_and_entity_type on audit_events (cost=0.57..12,172.54 rows=8,666 width=211) (actual time=0.268..29,107.200 rows=44,789 loops=1)

  • Index Cond: ((entity_id = 278,964) AND ((entity_type)::text = 'Project'::text))
Planning time : 1.521 ms
Execution time : 29,139.141 ms